스프링프로젝트

테이블 (4)

comments

  • num — number — NOT NULL
  • idx — number — NOT NULL
  • writer — varchar2(20) — NOT NULL
  • content — varcahr2(100) — NOT NULL
  • delete_yn — char(1) — NOT NULL

crew

  • large — number — NOT NULL
  • small — char(1) — NOT NULL
  • num — number — NOT NULL
  • crew_name — varchar2(50) — NOT NULL
  • crew_contents — varchar2(100) — NOT NULL
  • crew_limit — number — NOT NULL
  • crew_now — number — NOT NULL
  • crew_member — varchar2(100) — NOT NULL
  • crew_manager — varchar2(20) — NOT NULL

crew_board

  • num — number — NOT NULL
  • state — number — NOT NULL
  • large — number — NOT NULL
  • small — char(1) — NOT NULL
  • crew_name — varchar2(50) — NOT NULL
  • subject — varchar2(50) — NOT NULL
  • writer — varchar2(20) — NOT NULL
  • contents — varchar2(100) — NOT NULL
  • reg_date — date — NOT NULL

products

  • num — number — NOT NULL
  • kind — char(1) — NOT NULL
  • name — varchar2(20) — NOT NULL
  • price — number — NOT NULL
  • info — varchar2(100) — NOT NULL
  • image — varchar2(100) — NOT NULL
  • seller — varchar2(20) — NOT NULL
  • inputdate — date — NOT NULL
  • state — number — NOT NULL