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)