서울 에스라 가계부 월례회 자료 2023-05-19

Taebu commented 1 year ago

drop table `newezra`.`account_book`;

CREATE TABLE `newezra`.`account_book` (
  `ab_no` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `ab_class` VARCHAR(45) NULL,
  `ab_date` DATE NULL,
  `ab_type` VARCHAR(45) NULL,
  `ab_amount` INT UNSIGNED NULL,
  `ab_contents` TEXT NULL,
  `ab_datetime` DATETIME NULL,
  PRIMARY KEY (`ab_no`)) DEFAULT CHARSET='utf8' 
COMMENT = '서울 에스라 가계부 월례회 자료 2023-05-19';

Taebu commented 1 year ago

insert into `newezra`.`account_book`(ab_class, ab_date, ab_type,ab_amount,ab_contents,ab_datetime)
 values('media','2023-03-01','In','886523','이월액',now()),
('media','2023-03-24','Out','56364','ADOBE',now()),
('media','2023-04-01','Out','13500','구글계정',now()),
('media','2023-04-24','Out','56364','ADOBE',now()),
('media','2023-04-26','Out','95000','SHURE R185 단일지향성 카트리지',now()),
('media','2023-05-01','Out','13500','구글계정',now()),
('media','2023-05-14','Out','390000','블랙매직 ATEM Mini PRO',now()),
('media','2023-05-17','Out','25500','AUX케이블 3.5-55 3.5ST-2P55모노 1.5M',now()),
('media','2023-05-17','Out','6200','TrueAV USB-C to USB A 케이블 1M USB A to C',now()),
('media','2023-05-17','Out','5000','샌디스크 마이크로 SD 32G',now()),
('media','2023-05-19','In','3000','포인트 충전 반환',now()),
('media','2023-05-19','In','133','이자',now()),
('media','2023-06-01','Out','13500','구글계정',now());

Taebu commented 1 year ago

CREATE TABLE `newezra`.`account_user` (
  `au_no` INT UNSIGNED NOT NULL AUTO_INCREMENT,
  `au_id` VARCHAR(45) NULL,
  `au_password` VARCHAR(45) NULL,
  `ab_class` VARCHAR(45) NULL,
  `au_name` VARCHAR(45) NULL,
  `au_datetime` DATETIME NULL,
  `au_bankno` VARCHAR(45) NULL,
  `au_bankname` VARCHAR(45) NULL,
  PRIMARY KEY (`au_no`)) DEFAULT CHARSET='utf8' 
COMMENT = '서울에스라교회 관리 유저    2023-05-21';

Taebu / ezrachurch

서울 에스라 가계부 월례회 자료 2023-05-19 #64