Alcohol: as long as the owner of the property allows and CC, its fine.
§ 14-269.3. Carrying weapons into assemblies and establishments where alcoholic beverages are sold and consumed.
(a) It shall be unlawful for any person to carry any gun, rifle, or pistol into any assembly where a fee has been charged for admission thereto, or into any establishment in which alcoholic beverages are sold and consumed. Any person violating the provisions of this section shall be guilty of a Class 1 misdemeanor.
(b) This section shall not apply to any of the following:
(1) A person exempted from the provisions of G.S. 14-269.
(2) The owner or lessee of the premises or business establishment.
(3) A person participating in the event, if the person is carrying a gun, rifle, or pistol with the permission of the owner, lessee, or person or organization sponsoring the event.
(4) A person registered or hired as a security guard by the owner, lessee, or person or organization sponsoring the event.
(5) A person carrying a handgun if the person has a valid concealed handgun permit issued in accordance with Article 54B of this Chapter, has a concealed handgun permit considered valid under G.S. 14-415.24, or is exempt from obtaining a permit pursuant to G.S. 14-415.25. This subdivision shall not be construed to permit a person to carry a handgun on any premises where the person in legal possession or control of the premises has posted a conspicuous notice prohibiting the carrying of a concealed handgun on the premises in accordance with G.S. 14-415.11(c). (1977, c. 1016, s. 1; 1981, c. 412, s. 4; c. 747, s. 66; 1993, c. 539, s. 165; 1994, Ex. Sess., c. 24, s. 14(c); 2013-369, s. 3.)
Parade/Funerals: as long as the individual is CC, its fine.
§ 14-277.2. Weapons at parades, etc., prohibited.
(a) It shall be unlawful for any person participating in, affiliated with, or present as a spectator at any parade, funeral procession, picket line, or demonstration upon any private health care facility or upon any public place owned or under the control of the State or any of its political subdivisions to willfully or intentionally possess or have immediate access to any dangerous weapon. Violation of this subsection shall be a Class 1 misdemeanor. It shall be presumed that any rifle or gun carried on a rack in a pickup truck at a holiday parade or in a funeral procession does not violate the terms of this act.
(b) For the purposes of this section the term "dangerous weapon" shall include those weapons specified in G.S. 14-269, 14-269.2, 14-284.1, or 14-288.8 or any other object capable of inflicting serious bodily injury or death when used as a weapon.
(c) The provisions of this section shall not apply to a person exempted by the provisions of G.S. 14-269(b) or to persons authorized by State or federal law to carry dangerous weapons in the performance of their duties or to any person who obtains a permit to carry a dangerous weapon at a parade, funeral procession, picket line, or demonstration from the sheriff or police chief, whichever is appropriate, of the locality where such parade, funeral procession, picket line, or demonstration is to take place.
(d) The provisions of this section shall not apply to concealed carry of a handgun at a parade or funeral procession by a person with a valid permit issued in accordance with Article 54B of this Chapter, with a permit considered valid under G.S. 14-415.24, or who is exempt from obtaining a permit pursuant to G.S. 14-415.25. This subsection shall not be construed to permit a person to carry a concealed handgun on any premises where the person in legal possession or control of the premises has posted a conspicuous notice prohibiting the carrying of a concealed handgun on the premises in accordance with G.S. 14-415.11(c). (1981, c. 684, s. 1; 1983, c. 633; 1993, c. 412, s. 2; c. 539, s. 174; 1994, Ex. Sess., c. 24, s. 14(c); 1997-238, s. 4; 2013-369, s. 15.)
Schools: There are changes and it varies.
Government Bdls: I believe this is the consensus in all states in general, not 100% sure.
Securing Firearms where children reside: That is just common sense.
§ 14-315.1. Storage of firearms to protect minors.
(a) Any person who resides in the same premises as a minor, owns or possesses a firearm, and stores or leaves the firearm (i) in a condition that the firearm can be discharged and (ii) in a manner that the person knew or should have known that an unsupervised minor would be able to gain access to the firearm, is guilty of a Class 1 misdemeanor if a minor gains access to the firearm without the lawful permission of the minor's parents or a person having charge of the minor and the minor:
(1) Possesses it in violation of G.S. 14-269.2(b);
(2) Exhibits it in a public place in a careless, angry, or threatening manner;
(3) Causes personal injury or death with it not in self defense; or
(4) Uses it in the commission of a crime.
(b) Nothing in this section shall prohibit a person from carrying a firearm on his or her body, or placed in such close proximity that it can be used as easily and quickly as if carried on the body.
(c) This section shall not apply if the minor obtained the firearm as a result of an unlawful entry by any person.
(d) "Minor" as used in this section means a person under 18 years of age who is not emancipated. (1993, c. 558, s. 2; 1994, Ex. Sess., c. 14, s. 11.)
I'll follow up with the statutory laws, not available to look them up right now.