ogae
테이블 (6)
관리자 (admin)
- admin (Primary Key) — character varying(50) — 기본 키 — NOT NULL
- admin_pass (Field) — character varying
- admin_name (Field2) — character varying(50)
- admin_bank (Field3) — character varying(50)
- admin_account (Field4) — character varying(50)
- admin_phone (Field5) — character varying(50) — NOT NULL
- admin_email (Field6) — character varying(50)
사업자 정보 (company_info)
- company_regcode (Primary Key) — character(12) — 기본 키 — NOT NULL
- company_name (Field) — character varying(30) — NOT NULL
- rep_name (Field2) — character varying(30) — NOT NULL
- company_address (Field3) — character varying(70) — NOT NULL
- company_ordercode (Field4) — character varying(50) — NOT NULL
- company_phone (Field5) — character varying(50)
- company_email (Field6) — character varying(50)
수익 (addincome)
- add_idx (Primary Key) — integer — 기본 키 — NOT NULL
- add_mount (Field) — integer
- add_resoun (Field2) — character varying
- add_method (Field3) — character varying
- reservce_idx (Field4) — character varying
이벤트 (event)
- event_idx (Primary Key) — integer — 기본 키 — NOT NULL
- event_title (Field) — character varying(70) — NOT NULL
- event_writer (Field2) — character varying(10) — NOT NULL
- event_content (Field3) — character varying(500) — NOT NULL
- event_condition (Field4) — boolean — NOT NULL
- event_regdate (Field5) — timestamp without time zone — NOT NULL
- event_modydate (Field6) — timestamp without time zone
- event_startdate (Field7) — date
- event_enddate (Field8) — date
이벤트 사진 (event_img)
- img_idx (Primary Key) — integer — 기본 키 — NOT NULL
- img_path (Field) — character varying — NOT NULL
- event_idx (Field2) — integer — NOT NULL