team3

Tables (4)

team_bills

  • seller — varchar2(20) — Foreign key → team_member.member_id — NOT NULL
  • buyer — varchar2(20) — NOT NULL
  • item_number — number(38) — NOT NULL
  • pay_date — date
  • pay_step — varchar2(100)

team_chat

  • from_id — varchar2(20) — Foreign key → team_member.member_id — NOT NULL
  • to_id — VARCHAR2(20) — NOT NULL
  • message — varchar2(100) — NOT NULL
  • timeline — date

team_item

  • item_number — number(38) — Primary key — NOT NULL
  • seller — varchar2(20) — Foreign key → team_member.member_id — NOT NULL
  • game — varchar2(100) — NOT NULL
  • categories — varchar2(100) — NOT NULL
  • servers — varchar2(100)
  • item_name — varchar2(100) — NOT NULL
  • item_info — varchar2(1000)
  • price — number(38)
  • count — number(38) — NOT NULL
  • up_date — date
  • image — varchar(1000)

team_member

  • member_id — varchar2(20) — Primary key — NOT NULL
  • password — varchar2(15) — NOT NULL
  • member_name — varchar2(10) — NOT NULL
  • birth — date — NOT NULL
  • phone — varchar2(20)
  • create_date — date
  • permission — varchar2(10)
  • grade — varchar2(5)
  • mileage — number(38)