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

시설 (facility)

  • Key — 기본 키 — NOT NULL

이벤트 (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